Parameter <name> specified where a table name is required. (Error 3216)

You created a parameter query that specifies an invalid parameter type. The following example produces this error.

PARAMETERS Param1 Text;

INSERT INTO Param1

SELECT *

FROM Customers;

Param1 is a text parameter, but the INSERT INTO statement expects a table name.

Change the parameter type from Text to TableID, and then try the operation again.